AcademicAdvisor 
EntityType  Independent 
Logical Entity Name  AcademicAdvisor 
Default Table Name  AdAdvisor 
Logical Only  YES 
Owner   
Definition 
CREATE VIEW dbo.AdAdvisorASSELECT     syStaff.code,     systaff.sycampusgrpid,     systaff.lastname,         systaff.firstname,     systaff.addr1,     systaff.addr2,     systaff.city,         systaff.state,     systaff.zip,     systaff.phone,     systaff.active,         systaff.userid,     systaff.dateadded,     systaff.datelstmod,         systaff.descrip,     syStaff.syStaffID AS AdAdvisorIDFROM syStaffByGroup (nolock)LEFT OUTER JOIN syStaff (nolock)   ON syStaff.syStaffID = syStaffByGroup.syStaffID LEFT OUTER JOIN syStaffGroup (nolock)   ON syStaffGroup.syStaffGroupID = syStaffByGroup.syStaffGroupIDWHERE syStaffGroup.code = 'ACAD'
 
Note 
 

AcademicAdvisor Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 

AcademicAdvisor Keys 
Key Name  Key Type  Keys 

AcademicAdvisor Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

AcademicAdvisor Check Constraints 
Check Constraint Name  CheckConstraint 

AcademicAdvisor Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
AcademicAdvisor 
NO       
Physical (Microsoft SQL Server)
Does Not Exist 
NO       

AcademicAdvisor Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 

AcademicAdvisor Data Movement Rules 
Name  Type  Rule Text/Value